-
Re: Visible audit log instead of "view cell history" for numerous lines of data
hi @VictoriaL do you have datamesh? If so, you could make this work. You would need a unique id for the row (I’ll assume that’s the Row ID for now). I had ChatGPT write the rest of the instructions: …1 · -
Re: Survey Result Dashboard COUNTIF CONTAINS formula
Hi @MikeChapNL — to fix the COUNTIFS, update the formula to include the @cell reference and change the semi-colon to a comma (unless the semi-colon is a convention specific to the Netherlands instanc…1 · -
Using DataMesh to Split One Line Onto Multiple Lines (for Forms Entries and Other Uses)
This is a problem I've heard a few times so I'm answering it in a separate post for reference in long form. I'm using the example from @WtaylorW's question over here. The basic need is to take one li…8 · -
Re: I need to create a row for multiple names recorded in a form and duplicate the other cells
@WtaylorW do you have DataMesh? That would make it easy. However, you can set up another sheet to make this happen. I'll show you how to do this with one employee name -- just repeat for each column.…1 · -
Re: How do I prevent the cell I am highlighting from auto-deleting the text in the cell?
@Wilcha that's super weird. I've never heard of this happening before. If you have a cell highlighted and type anything, you will type in the cell, but it shouldn't just delete something in the cell.…1 ·